﻿CREATE TABLE [dbo].[City] (
    [Id]            INT           NOT NULL,
    [State_Id]      INT           NOT NULL,
    [CityCode]      VARCHAR (50)  NOT NULL,
    [CityType]      SMALLINT      NOT NULL,
    [IsActive]      BIT           NOT NULL,
    [DisplayOrder]  INT           NULL,
    [IsDeprecated]  BIT           NOT NULL,
    [CityName]      VARCHAR (100) NULL,
    [CityLocalName] NVARCHAR (20) NULL,
    [InsertDate]    DATETIME      NOT NULL,
    [UpdateDate]    DATETIME      NOT NULL
);

